{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='本田')]\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口本田>>']\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LVH')|(all1['3']=='LHG')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>DHW7101FCMSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1243,1253</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>988</td>\n",
       "      <td>92</td>\n",
       "      <td>LVHFC752×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>DHW7102FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1275,1279</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>988</td>\n",
       "      <td>92</td>\n",
       "      <td>LVHFC762×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>DHW7153FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1306</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC166×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>DHW7154FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1326,1329</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC160×××××××××,LVHFC168×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>DHW7153FCMSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1275</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC156×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>DHW7101FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1256,1265,1266</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>988</td>\n",
       "      <td>92</td>\n",
       "      <td>LVHFC762×××××××××,LVHFC763×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>DHW7154FCCSF</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1330,1333</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC167×××××××××,LVHFC169×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DHW7153FCCSF</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1303,1309</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC165×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>DHW7154FCCSE</td>\n",
       "      <td>思域</td>\n",
       "      <td>1326,1329</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC160×××××××××,LVHFC168×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>DHW7154FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1326,1329</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC160×××××××××,LVHFC168×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>DHW7101FCMSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1243,1253</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>988</td>\n",
       "      <td>92</td>\n",
       "      <td>LVHFC752×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>DHW7102FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1275,1279</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>988</td>\n",
       "      <td>92</td>\n",
       "      <td>LVHFC762×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>DHW7101FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1256,1265,1266</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>988</td>\n",
       "      <td>92</td>\n",
       "      <td>LVHFC762×××××××××,LVHFC763×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>DHW7153FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1306</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC166×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>DHW7153FCMSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1275</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC156×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>DHW7154FCCSE</td>\n",
       "      <td>思域(CIVIC)</td>\n",
       "      <td>1326,1329</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649</td>\n",
       "      <td>1800</td>\n",
       "      <td>1416</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LVHFC160×××××××××,LVHFC168×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2700</td>\n",
       "      <td>4649x1800x1416</td>\n",
       "      <td>本田</td>\n",
       "      <td>思域</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>GHA7150AAC6B</td>\n",
       "      <td>本田(HONDA)</td>\n",
       "      <td>1478</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893</td>\n",
       "      <td>1862</td>\n",
       "      <td>1449</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LHGCV164×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893x1862x1449</td>\n",
       "      <td>本田</td>\n",
       "      <td>雅阁</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>GHA7150AAC6A</td>\n",
       "      <td>本田(HONDA)</td>\n",
       "      <td>1440</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893</td>\n",
       "      <td>1862</td>\n",
       "      <td>1449</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LHGCV162×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893x1862x1449</td>\n",
       "      <td>本田</td>\n",
       "      <td>雅阁</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>GHA7150AAC6C</td>\n",
       "      <td>本田(HONDA)</td>\n",
       "      <td>1494,1495,1513,1523</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893</td>\n",
       "      <td>1862</td>\n",
       "      <td>1449</td>\n",
       "      <td>1498</td>\n",
       "      <td>143</td>\n",
       "      <td>LHGCV164×××××××××,LHGCV166×××××××××,LHGCV168××...</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893x1862x1449</td>\n",
       "      <td>本田</td>\n",
       "      <td>雅阁</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>GHA7150AAC5B</td>\n",
       "      <td>本田(HONDA)</td>\n",
       "      <td>1475</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893</td>\n",
       "      <td>1862</td>\n",
       "      <td>1449</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LHGCV163×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893x1862x1449</td>\n",
       "      <td>本田</td>\n",
       "      <td>雅阁</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>GHA7150AAC5C</td>\n",
       "      <td>本田(HONDA)</td>\n",
       "      <td>1485,1493,1511,1519</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893</td>\n",
       "      <td>1862</td>\n",
       "      <td>1449</td>\n",
       "      <td>1498</td>\n",
       "      <td>143</td>\n",
       "      <td>LHGCV163×××××××××,LHGCV165×××××××××,LHGCV167××...</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893x1862x1449</td>\n",
       "      <td>本田</td>\n",
       "      <td>雅阁</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>GHA7150AAC5A</td>\n",
       "      <td>本田(HONDA)</td>\n",
       "      <td>1437</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893</td>\n",
       "      <td>1862</td>\n",
       "      <td>1449</td>\n",
       "      <td>1498</td>\n",
       "      <td>130</td>\n",
       "      <td>LHGCV161×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4893x1862x1449</td>\n",
       "      <td>本田</td>\n",
       "      <td>雅阁</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>HG7155CAC5A</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1094,1117,1091</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM662×××××××××\\r,LHGGM664×××××××××\\r,LHGGM6...</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>HG7155CAM5A</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1078</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM652×××××××××\\r,LHGGM654×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>HG7155CAM5A</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1078</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM652×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>HG7155CAC5A</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1094,1117,1091</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM662×××××××××,LHGGM664×××××××××,LHGGM663××...</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>HG7155CAM5E</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1104</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM654×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>HG7155CAC5C</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1099,1121,1097</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM662×××××××××,LHGGM664×××××××××,LHGGM663××...</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>HG7155CAM5D</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1082</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM652×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>HG7155CAM5B</td>\n",
       "      <td>锋范(CITY)</td>\n",
       "      <td>1099</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450</td>\n",
       "      <td>1695</td>\n",
       "      <td>1477</td>\n",
       "      <td>1498</td>\n",
       "      <td>96</td>\n",
       "      <td>LHGGM654×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2600</td>\n",
       "      <td>4450x1695x1477</td>\n",
       "      <td>本田</td>\n",
       "      <td>锋范</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>697</th>\n",
       "      <td>HG6480BB</td>\n",
       "      <td>奥德赛(ODYSSEY)</td>\n",
       "      <td>1676,1693</td>\n",
       "      <td>2830</td>\n",
       "      <td>4770</td>\n",
       "      <td>1800</td>\n",
       "      <td>1582</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LHGRB185×××××××××LHGRB187×××××××××LHGRB189××××...</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4770x1800x1582</td>\n",
       "      <td>本田</td>\n",
       "      <td>奥德赛</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>698</th>\n",
       "      <td>HG6480B</td>\n",
       "      <td>奥德赛(ODYSSEY)</td>\n",
       "      <td>1676,1693</td>\n",
       "      <td>2830</td>\n",
       "      <td>4770</td>\n",
       "      <td>1800</td>\n",
       "      <td>1582</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LHGRB184××××××××× LHGRB186××××××××× LHGRB188××...</td>\n",
       "      <td>广州本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4770x1800x1582</td>\n",
       "      <td>本田</td>\n",
       "      <td>奥德赛</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>699</th>\n",
       "      <td>HG6480BB</td>\n",
       "      <td>奥德赛(ODYSSEY)</td>\n",
       "      <td>1676,1693</td>\n",
       "      <td>2830</td>\n",
       "      <td>4770</td>\n",
       "      <td>1800</td>\n",
       "      <td>1582</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LHGRB185××××××××× LHGRB187××××××××× LHGRB189××...</td>\n",
       "      <td>广州本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4770x1800x1582</td>\n",
       "      <td>本田</td>\n",
       "      <td>奥德赛</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>700</th>\n",
       "      <td>HG6480AB</td>\n",
       "      <td>奥德赛(ODYSSEY)</td>\n",
       "      <td>1676,1693</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765</td>\n",
       "      <td>1800</td>\n",
       "      <td>1582</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LHGRB185×××××××××\\rLHGRB188×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765x1800x1582</td>\n",
       "      <td>本田</td>\n",
       "      <td>奥德赛</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701</th>\n",
       "      <td>HG6480</td>\n",
       "      <td>奥德赛(ODYSSEY)</td>\n",
       "      <td>1693,1676</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765</td>\n",
       "      <td>1800</td>\n",
       "      <td>1582</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LHGRB184×××××××××\\rLHGRB187×××××××××</td>\n",
       "      <td>广汽本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765x1800x1582</td>\n",
       "      <td>本田</td>\n",
       "      <td>奥德赛</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>702</th>\n",
       "      <td>HG6480AB</td>\n",
       "      <td>奥德赛(ODYSSEY)</td>\n",
       "      <td>1676,1693</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765</td>\n",
       "      <td>1800</td>\n",
       "      <td>1582</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LHGRB185×××××××××\\rLHGRB188×××××××××</td>\n",
       "      <td>广州本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765x1800x1582</td>\n",
       "      <td>本田</td>\n",
       "      <td>奥德赛</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>703</th>\n",
       "      <td>HG6480</td>\n",
       "      <td>奥德赛(ODYSSEY)</td>\n",
       "      <td>1693,1676</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765</td>\n",
       "      <td>1800</td>\n",
       "      <td>1582</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LHGRB184×××××××××\\rLHGRB187×××××××××</td>\n",
       "      <td>广州本田汽车有限公司</td>\n",
       "      <td>LHG</td>\n",
       "      <td>2830</td>\n",
       "      <td>4765x1800x1582</td>\n",
       "      <td>本田</td>\n",
       "      <td>奥德赛</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>704</th>\n",
       "      <td>DHW6450B(CR-V2.0)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1590</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE285×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>705</th>\n",
       "      <td>DHW6453(CR-V2.4M)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1590</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>2354</td>\n",
       "      <td>125</td>\n",
       "      <td>LVHRE476×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>706</th>\n",
       "      <td>DHW6453B(CR-V2.4M)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1590</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>2354</td>\n",
       "      <td>125</td>\n",
       "      <td>LVHRE477×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>707</th>\n",
       "      <td>DHW6454(CR-V2.4)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1635</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>2354</td>\n",
       "      <td>125</td>\n",
       "      <td>LVHRE488×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708</th>\n",
       "      <td>DHW6451B(CR-V2.0M)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1555</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE275×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>709</th>\n",
       "      <td>DHW6452(CR-V2.4)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1625</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>2354</td>\n",
       "      <td>125</td>\n",
       "      <td>LVHRE486×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>710</th>\n",
       "      <td>DHW6452B(CR-V2.4)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1625</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>2354</td>\n",
       "      <td>125</td>\n",
       "      <td>LVHRE487×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>711</th>\n",
       "      <td>DHW6451(CR-V2.0M)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1555</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE274×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>712</th>\n",
       "      <td>DHW6450(CR-V2.0)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1590</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE284×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713</th>\n",
       "      <td>DHW6454B(CR-V2.4)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1635</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>2354</td>\n",
       "      <td>125</td>\n",
       "      <td>LVHRE489×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>714</th>\n",
       "      <td>DHW6457(CR-V2.0M)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1475</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE172×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>715</th>\n",
       "      <td>DHW6456(CR-V2.0)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1510</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE182×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>716</th>\n",
       "      <td>DHW6457B(CR-V2.0M)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1475</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE173×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>717</th>\n",
       "      <td>DHW6456B(CR-V2.0)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1510</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530</td>\n",
       "      <td>1820</td>\n",
       "      <td>1680</td>\n",
       "      <td>1997</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRE183×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4530x1820x1680</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>DHW6460(CR-Vi-VTEC)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1520</td>\n",
       "      <td>2620</td>\n",
       "      <td>4570</td>\n",
       "      <td>1780</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRD584×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2620</td>\n",
       "      <td>4570x1780x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>719</th>\n",
       "      <td>DHW6461(CR-V2.0i-VTEC)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1555</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRD584×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>DHW6462(CR-V2.0i-VTECM)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1525</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRD574×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>721</th>\n",
       "      <td>DHW6463(CR-V2.4i-VTEC)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1565</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LVHRD787×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>722</th>\n",
       "      <td>DHW6464(CR-V2.4i-VTECM)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1535</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LVHRD777×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>723</th>\n",
       "      <td>DHW6461A(CR-V2.0i-VTEC)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1555</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRD585×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>724</th>\n",
       "      <td>DHW6462A(CR-V2.0i-VTECM)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1525</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>1998</td>\n",
       "      <td>110</td>\n",
       "      <td>LVHRD575×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>725</th>\n",
       "      <td>DHW6463A(CR-V2.4i-VTEC)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1565</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LVHRD788×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>DHW6464A(CR-V2.4i-VTECM)</td>\n",
       "      <td>思威(CR-V)</td>\n",
       "      <td>1535</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630</td>\n",
       "      <td>1785</td>\n",
       "      <td>1710</td>\n",
       "      <td>2354</td>\n",
       "      <td>118</td>\n",
       "      <td>LVHRD778×××××××××</td>\n",
       "      <td>东风本田汽车有限公司</td>\n",
       "      <td>LVH</td>\n",
       "      <td>2625</td>\n",
       "      <td>4630x1785x1710</td>\n",
       "      <td>本田</td>\n",
       "      <td>本田CR-V</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>727 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  notice_type       brand_x          curb_weight Wheelbase  \\\n",
       "0                DHW7101FCMSE     思域(CIVIC)            1243,1253      2700   \n",
       "1                DHW7102FCCSE     思域(CIVIC)            1275,1279      2700   \n",
       "2                DHW7153FCCSE     思域(CIVIC)                 1306      2700   \n",
       "3                DHW7154FCCSE     思域(CIVIC)            1326,1329      2700   \n",
       "4                DHW7153FCMSE     思域(CIVIC)                 1275      2700   \n",
       "5                DHW7101FCCSE     思域(CIVIC)       1256,1265,1266      2700   \n",
       "6                DHW7154FCCSF     思域(CIVIC)            1330,1333      2700   \n",
       "7                DHW7153FCCSF     思域(CIVIC)            1303,1309      2700   \n",
       "8                DHW7154FCCSE            思域            1326,1329      2700   \n",
       "9                DHW7154FCCSE     思域(CIVIC)            1326,1329      2700   \n",
       "10               DHW7101FCMSE     思域(CIVIC)            1243,1253      2700   \n",
       "11               DHW7102FCCSE     思域(CIVIC)            1275,1279      2700   \n",
       "12               DHW7101FCCSE     思域(CIVIC)       1256,1265,1266      2700   \n",
       "13               DHW7153FCCSE     思域(CIVIC)                 1306      2700   \n",
       "14               DHW7153FCMSE     思域(CIVIC)                 1275      2700   \n",
       "15               DHW7154FCCSE     思域(CIVIC)            1326,1329      2700   \n",
       "16               GHA7150AAC6B     本田(HONDA)                 1478      2830   \n",
       "17               GHA7150AAC6A     本田(HONDA)                 1440      2830   \n",
       "18               GHA7150AAC6C     本田(HONDA)  1494,1495,1513,1523      2830   \n",
       "19               GHA7150AAC5B     本田(HONDA)                 1475      2830   \n",
       "20               GHA7150AAC5C     本田(HONDA)  1485,1493,1511,1519      2830   \n",
       "21               GHA7150AAC5A     本田(HONDA)                 1437      2830   \n",
       "22                HG7155CAC5A      锋范(CITY)       1094,1117,1091      2600   \n",
       "23                HG7155CAM5A      锋范(CITY)                 1078      2600   \n",
       "24                HG7155CAM5A      锋范(CITY)                 1078      2600   \n",
       "25                HG7155CAC5A      锋范(CITY)       1094,1117,1091      2600   \n",
       "26                HG7155CAM5E      锋范(CITY)                 1104      2600   \n",
       "27                HG7155CAC5C      锋范(CITY)       1099,1121,1097      2600   \n",
       "28                HG7155CAM5D      锋范(CITY)                 1082      2600   \n",
       "29                HG7155CAM5B      锋范(CITY)                 1099      2600   \n",
       "..                        ...           ...                  ...       ...   \n",
       "697                  HG6480BB  奥德赛(ODYSSEY)            1676,1693      2830   \n",
       "698                   HG6480B  奥德赛(ODYSSEY)            1676,1693      2830   \n",
       "699                  HG6480BB  奥德赛(ODYSSEY)            1676,1693      2830   \n",
       "700                  HG6480AB  奥德赛(ODYSSEY)            1676,1693      2830   \n",
       "701                    HG6480  奥德赛(ODYSSEY)            1693,1676      2830   \n",
       "702                  HG6480AB  奥德赛(ODYSSEY)            1676,1693      2830   \n",
       "703                    HG6480  奥德赛(ODYSSEY)            1693,1676      2830   \n",
       "704         DHW6450B(CR-V2.0)      思威(CR-V)                 1590      2620   \n",
       "705         DHW6453(CR-V2.4M)      思威(CR-V)                 1590      2620   \n",
       "706        DHW6453B(CR-V2.4M)      思威(CR-V)                 1590      2620   \n",
       "707          DHW6454(CR-V2.4)      思威(CR-V)                 1635      2620   \n",
       "708        DHW6451B(CR-V2.0M)      思威(CR-V)                 1555      2620   \n",
       "709          DHW6452(CR-V2.4)      思威(CR-V)                 1625      2620   \n",
       "710         DHW6452B(CR-V2.4)      思威(CR-V)                 1625      2620   \n",
       "711         DHW6451(CR-V2.0M)      思威(CR-V)                 1555      2620   \n",
       "712          DHW6450(CR-V2.0)      思威(CR-V)                 1590      2620   \n",
       "713         DHW6454B(CR-V2.4)      思威(CR-V)                 1635      2620   \n",
       "714         DHW6457(CR-V2.0M)      思威(CR-V)                 1475      2620   \n",
       "715          DHW6456(CR-V2.0)      思威(CR-V)                 1510      2620   \n",
       "716        DHW6457B(CR-V2.0M)      思威(CR-V)                 1475      2620   \n",
       "717         DHW6456B(CR-V2.0)      思威(CR-V)                 1510      2620   \n",
       "718       DHW6460(CR-Vi-VTEC)      思威(CR-V)                 1520      2620   \n",
       "719    DHW6461(CR-V2.0i-VTEC)      思威(CR-V)                 1555      2625   \n",
       "720   DHW6462(CR-V2.0i-VTECM)      思威(CR-V)                 1525      2625   \n",
       "721    DHW6463(CR-V2.4i-VTEC)      思威(CR-V)                 1565      2625   \n",
       "722   DHW6464(CR-V2.4i-VTECM)      思威(CR-V)                 1535      2625   \n",
       "723   DHW6461A(CR-V2.0i-VTEC)      思威(CR-V)                 1555      2625   \n",
       "724  DHW6462A(CR-V2.0i-VTECM)      思威(CR-V)                 1525      2625   \n",
       "725   DHW6463A(CR-V2.4i-VTEC)      思威(CR-V)                 1565      2625   \n",
       "726  DHW6464A(CR-V2.4i-VTECM)      思威(CR-V)                 1535      2625   \n",
       "\n",
       "    car_length car_width car_height Displacement power  \\\n",
       "0         4649      1800       1416          988    92   \n",
       "1         4649      1800       1416          988    92   \n",
       "2         4649      1800       1416         1498   130   \n",
       "3         4649      1800       1416         1498   130   \n",
       "4         4649      1800       1416         1498   130   \n",
       "5         4649      1800       1416          988    92   \n",
       "6         4649      1800       1416         1498   130   \n",
       "7         4649      1800       1416         1498   130   \n",
       "8         4649      1800       1416         1498   130   \n",
       "9         4649      1800       1416         1498   130   \n",
       "10        4649      1800       1416          988    92   \n",
       "11        4649      1800       1416          988    92   \n",
       "12        4649      1800       1416          988    92   \n",
       "13        4649      1800       1416         1498   130   \n",
       "14        4649      1800       1416         1498   130   \n",
       "15        4649      1800       1416         1498   130   \n",
       "16        4893      1862       1449         1498   130   \n",
       "17        4893      1862       1449         1498   130   \n",
       "18        4893      1862       1449         1498   143   \n",
       "19        4893      1862       1449         1498   130   \n",
       "20        4893      1862       1449         1498   143   \n",
       "21        4893      1862       1449         1498   130   \n",
       "22        4450      1695       1477         1498    96   \n",
       "23        4450      1695       1477         1498    96   \n",
       "24        4450      1695       1477         1498    96   \n",
       "25        4450      1695       1477         1498    96   \n",
       "26        4450      1695       1477         1498    96   \n",
       "27        4450      1695       1477         1498    96   \n",
       "28        4450      1695       1477         1498    96   \n",
       "29        4450      1695       1477         1498    96   \n",
       "..         ...       ...        ...          ...   ...   \n",
       "697       4770      1800       1582         2354   118   \n",
       "698       4770      1800       1582         2354   118   \n",
       "699       4770      1800       1582         2354   118   \n",
       "700       4765      1800       1582         2354   118   \n",
       "701       4765      1800       1582         2354   118   \n",
       "702       4765      1800       1582         2354   118   \n",
       "703       4765      1800       1582         2354   118   \n",
       "704       4530      1820       1680         1997   110   \n",
       "705       4530      1820       1680         2354   125   \n",
       "706       4530      1820       1680         2354   125   \n",
       "707       4530      1820       1680         2354   125   \n",
       "708       4530      1820       1680         1997   110   \n",
       "709       4530      1820       1680         2354   125   \n",
       "710       4530      1820       1680         2354   125   \n",
       "711       4530      1820       1680         1997   110   \n",
       "712       4530      1820       1680         1997   110   \n",
       "713       4530      1820       1680         2354   125   \n",
       "714       4530      1820       1680         1997   110   \n",
       "715       4530      1820       1680         1997   110   \n",
       "716       4530      1820       1680         1997   110   \n",
       "717       4530      1820       1680         1997   110   \n",
       "718       4570      1780       1710         1998   110   \n",
       "719       4630      1785       1710         1998   110   \n",
       "720       4630      1785       1710         1998   110   \n",
       "721       4630      1785       1710         2354   118   \n",
       "722       4630      1785       1710         2354   118   \n",
       "723       4630      1785       1710         1998   110   \n",
       "724       4630      1785       1710         1998   110   \n",
       "725       4630      1785       1710         2354   118   \n",
       "726       4630      1785       1710         2354   118   \n",
       "\n",
       "                                                   vin car_factory    3  \\\n",
       "0                                    LVHFC752×××××××××  东风本田汽车有限公司  LVH   \n",
       "1                                    LVHFC762×××××××××  东风本田汽车有限公司  LVH   \n",
       "2                                    LVHFC166×××××××××  东风本田汽车有限公司  LVH   \n",
       "3                  LVHFC160×××××××××,LVHFC168×××××××××  东风本田汽车有限公司  LVH   \n",
       "4                                    LVHFC156×××××××××  东风本田汽车有限公司  LVH   \n",
       "5                  LVHFC762×××××××××,LVHFC763×××××××××  东风本田汽车有限公司  LVH   \n",
       "6                  LVHFC167×××××××××,LVHFC169×××××××××  东风本田汽车有限公司  LVH   \n",
       "7                                    LVHFC165×××××××××  东风本田汽车有限公司  LVH   \n",
       "8                  LVHFC160×××××××××,LVHFC168×××××××××  东风本田汽车有限公司  LVH   \n",
       "9                  LVHFC160×××××××××,LVHFC168×××××××××  东风本田汽车有限公司  LVH   \n",
       "10                                   LVHFC752×××××××××  东风本田汽车有限公司  LVH   \n",
       "11                                   LVHFC762×××××××××  东风本田汽车有限公司  LVH   \n",
       "12                 LVHFC762×××××××××,LVHFC763×××××××××  东风本田汽车有限公司  LVH   \n",
       "13                                   LVHFC166×××××××××  东风本田汽车有限公司  LVH   \n",
       "14                                   LVHFC156×××××××××  东风本田汽车有限公司  LVH   \n",
       "15                 LVHFC160×××××××××,LVHFC168×××××××××  东风本田汽车有限公司  LVH   \n",
       "16                                   LHGCV164×××××××××  广汽本田汽车有限公司  LHG   \n",
       "17                                   LHGCV162×××××××××  广汽本田汽车有限公司  LHG   \n",
       "18   LHGCV164×××××××××,LHGCV166×××××××××,LHGCV168××...  广汽本田汽车有限公司  LHG   \n",
       "19                                   LHGCV163×××××××××  广汽本田汽车有限公司  LHG   \n",
       "20   LHGCV163×××××××××,LHGCV165×××××××××,LHGCV167××...  广汽本田汽车有限公司  LHG   \n",
       "21                                   LHGCV161×××××××××  广汽本田汽车有限公司  LHG   \n",
       "22   LHGGM662×××××××××\\r,LHGGM664×××××××××\\r,LHGGM6...  广汽本田汽车有限公司  LHG   \n",
       "23               LHGGM652×××××××××\\r,LHGGM654×××××××××  广汽本田汽车有限公司  LHG   \n",
       "24                                   LHGGM652×××××××××  广汽本田汽车有限公司  LHG   \n",
       "25   LHGGM662×××××××××,LHGGM664×××××××××,LHGGM663××...  广汽本田汽车有限公司  LHG   \n",
       "26                                   LHGGM654×××××××××  广汽本田汽车有限公司  LHG   \n",
       "27   LHGGM662×××××××××,LHGGM664×××××××××,LHGGM663××...  广汽本田汽车有限公司  LHG   \n",
       "28                                   LHGGM652×××××××××  广汽本田汽车有限公司  LHG   \n",
       "29                                   LHGGM654×××××××××  广汽本田汽车有限公司  LHG   \n",
       "..                                                 ...         ...  ...   \n",
       "697  LHGRB185×××××××××LHGRB187×××××××××LHGRB189××××...  广汽本田汽车有限公司  LHG   \n",
       "698  LHGRB184××××××××× LHGRB186××××××××× LHGRB188××...  广州本田汽车有限公司  LHG   \n",
       "699  LHGRB185××××××××× LHGRB187××××××××× LHGRB189××...  广州本田汽车有限公司  LHG   \n",
       "700               LHGRB185×××××××××\\rLHGRB188×××××××××  广汽本田汽车有限公司  LHG   \n",
       "701               LHGRB184×××××××××\\rLHGRB187×××××××××  广汽本田汽车有限公司  LHG   \n",
       "702               LHGRB185×××××××××\\rLHGRB188×××××××××  广州本田汽车有限公司  LHG   \n",
       "703               LHGRB184×××××××××\\rLHGRB187×××××××××  广州本田汽车有限公司  LHG   \n",
       "704                                  LVHRE285×××××××××  东风本田汽车有限公司  LVH   \n",
       "705                                  LVHRE476×××××××××  东风本田汽车有限公司  LVH   \n",
       "706                                  LVHRE477×××××××××  东风本田汽车有限公司  LVH   \n",
       "707                                  LVHRE488×××××××××  东风本田汽车有限公司  LVH   \n",
       "708                                  LVHRE275×××××××××  东风本田汽车有限公司  LVH   \n",
       "709                                  LVHRE486×××××××××  东风本田汽车有限公司  LVH   \n",
       "710                                  LVHRE487×××××××××  东风本田汽车有限公司  LVH   \n",
       "711                                  LVHRE274×××××××××  东风本田汽车有限公司  LVH   \n",
       "712                                  LVHRE284×××××××××  东风本田汽车有限公司  LVH   \n",
       "713                                  LVHRE489×××××××××  东风本田汽车有限公司  LVH   \n",
       "714                                  LVHRE172×××××××××  东风本田汽车有限公司  LVH   \n",
       "715                                  LVHRE182×××××××××  东风本田汽车有限公司  LVH   \n",
       "716                                  LVHRE173×××××××××  东风本田汽车有限公司  LVH   \n",
       "717                                  LVHRE183×××××××××  东风本田汽车有限公司  LVH   \n",
       "718                                  LVHRD584×××××××××  东风本田汽车有限公司  LVH   \n",
       "719                                  LVHRD584×××××××××  东风本田汽车有限公司  LVH   \n",
       "720                                  LVHRD574×××××××××  东风本田汽车有限公司  LVH   \n",
       "721                                  LVHRD787×××××××××  东风本田汽车有限公司  LVH   \n",
       "722                                  LVHRD777×××××××××  东风本田汽车有限公司  LVH   \n",
       "723                                  LVHRD585×××××××××  东风本田汽车有限公司  LVH   \n",
       "724                                  LVHRD575×××××××××  东风本田汽车有限公司  LVH   \n",
       "725                                  LVHRD788×××××××××  东风本田汽车有限公司  LVH   \n",
       "726                                  LVHRD778×××××××××  东风本田汽车有限公司  LVH   \n",
       "\n",
       "    轴距[mm]       长×宽×高[mm] brand_y   style  factory  \n",
       "0     2700  4649x1800x1416      本田      思域        6  \n",
       "1     2700  4649x1800x1416      本田      思域        6  \n",
       "2     2700  4649x1800x1416      本田      思域        6  \n",
       "3     2700  4649x1800x1416      本田      思域        6  \n",
       "4     2700  4649x1800x1416      本田      思域        6  \n",
       "5     2700  4649x1800x1416      本田      思域        6  \n",
       "6     2700  4649x1800x1416      本田      思域        6  \n",
       "7     2700  4649x1800x1416      本田      思域        6  \n",
       "8     2700  4649x1800x1416      本田      思域        6  \n",
       "9     2700  4649x1800x1416      本田      思域        6  \n",
       "10    2700  4649x1800x1416      本田      思域        6  \n",
       "11    2700  4649x1800x1416      本田      思域        6  \n",
       "12    2700  4649x1800x1416      本田      思域        6  \n",
       "13    2700  4649x1800x1416      本田      思域        6  \n",
       "14    2700  4649x1800x1416      本田      思域        6  \n",
       "15    2700  4649x1800x1416      本田      思域        6  \n",
       "16    2830  4893x1862x1449      本田      雅阁        6  \n",
       "17    2830  4893x1862x1449      本田      雅阁        6  \n",
       "18    2830  4893x1862x1449      本田      雅阁        6  \n",
       "19    2830  4893x1862x1449      本田      雅阁        6  \n",
       "20    2830  4893x1862x1449      本田      雅阁        6  \n",
       "21    2830  4893x1862x1449      本田      雅阁        6  \n",
       "22    2600  4450x1695x1477      本田      锋范        7  \n",
       "23    2600  4450x1695x1477      本田      锋范        7  \n",
       "24    2600  4450x1695x1477      本田      锋范        7  \n",
       "25    2600  4450x1695x1477      本田      锋范        7  \n",
       "26    2600  4450x1695x1477      本田      锋范        7  \n",
       "27    2600  4450x1695x1477      本田      锋范        7  \n",
       "28    2600  4450x1695x1477      本田      锋范        7  \n",
       "29    2600  4450x1695x1477      本田      锋范        7  \n",
       "..     ...             ...     ...     ...      ...  \n",
       "697   2830  4770x1800x1582      本田     奥德赛       10  \n",
       "698   2830  4770x1800x1582      本田     奥德赛       10  \n",
       "699   2830  4770x1800x1582      本田     奥德赛       10  \n",
       "700   2830  4765x1800x1582      本田     奥德赛        7  \n",
       "701   2830  4765x1800x1582      本田     奥德赛        7  \n",
       "702   2830  4765x1800x1582      本田     奥德赛        7  \n",
       "703   2830  4765x1800x1582      本田     奥德赛        7  \n",
       "704   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "705   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "706   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "707   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "708   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "709   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "710   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "711   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "712   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "713   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "714   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "715   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "716   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "717   2620  4530x1820x1680      本田  本田CR-V       10  \n",
       "718   2620  4570x1780x1710      本田  本田CR-V        1  \n",
       "719   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "720   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "721   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "722   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "723   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "724   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "725   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "726   2625  4630x1785x1710      本田  本田CR-V       10  \n",
       "\n",
       "[727 rows x 17 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('本田_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
